﻿
CREATE PROCEDURE [dbo].[OPM_ReturnReason_Update]
(
	@Id  int,
	@Name  nvarchar(50),
	@Description  nvarchar(500),
	@DisplayOrder  int,
	@Published  int,
	@UpdatedBy int
)

AS

    UPDATE dbo.[OPM_ReturnReason]
	SET 
		[Name] = @Name,
		[Description] = @Description,
		[DisplayOrder] = @DisplayOrder,
		[Published] = @Published,
		[UpdatedBy] = @UpdatedBy,
		[UpdatedOn] = getdate()
	WHERE [Id] = @Id